
USE [bmig_Mensual_Post_cadena]
GO

IF EXISTS (SELECT name FROM   sysobjects WHERE  name = 'WASP_M0011_CREATBL_ValSegSalud' AND type = 'P')
    DROP PROCEDURE [dbo].[WASP_M0011_CREATBL_ValSegSalud]
GO

CREATE PROCEDURE [dbo].[WASP_M0011_CREATBL_ValSegSalud]

AS


BEGIN

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[valsegSalud]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[valsegSalud]

		CREATE TABLE [dbo].[valsegSalud] (
			[ppsuc] [int] NOT NULL ,
			[ppcta] [int] NOT NULL ,
			[ppoper] [int] NOT NULL ,
			[ppimp11] [decimal](17, 2) NULL ,
			[ppimp12] [decimal](17, 2) NULL ,
			[ppimp13] [decimal](17, 2) NULL ,
			[ppimp14] [decimal](17, 2) NULL ,
			[ppimp15] [decimal](17, 2) NULL ,
			[ppimp16] [decimal](17, 2) NULL ,
			[ppimp17] [decimal](17, 2) NULL ,
			[ppimp18] [decimal](17, 2) NULL ,
			[ppimp19] [decimal](17, 2) NULL 
		) ON [PRIMARY]
		
END